www.gusucode.com > ROCKOA PHP协同办公OA办公系统 v2.0PHP源码程序 > ROCKOA PHP协同办公OA办公系统 v2.0/rockoa_v2.0/rockoa_v2.0/webrock/model/daibanModel.php
<?php class daibanClassModel extends Model { //待办 public function dai($uids, $sp='<br>') { $arows = m('flow_set')->getall('isflow = 1 order by `sort`', "`num`,`name`,`table`,`menunum`,`summary`"); $rows = array(); $mwhere = m('where'); $uid = '0'; $rudb = m('flow_course'); foreach($arows as $k=>$rs){ $whre = $mwhere->getstring('flowset_'.$rs['num']); $rsto = m($rs['table'])->getall("`status` in(0,2) and ifnull(uid, 0)>0 and `isturn`=1 and instr(concat(',', nowcheckid, ','), ',$uids,')>0 $whre"); $ztarr = $rudb->getcourseact($rs['num']); foreach($rsto as $k1=>$rs1){ $ztname = $this->getstatus($ztarr, $rs1, $sp); $summary = $rs['summary']; $summary = $this->rock->reparr($summary, $rs1); $rows[] = array( 'modenum' => $rs['num'], 'modename' => $rs['name'], 'tablename' => $rs['table'], 'summary' => $summary, 'uid' => $rs1['uid'], 'mid' => $rs1['id'], 'optdt' => $rs1['optdt'], 'statusman' => $ztname, 'notbtnarr' => $rudb->getcheckact($rs['table'], $rs1['id']) ); $uid.=','.$rs1['uid']; } } $uarr = m('admin')->getall("id in($uid)", '`name`,`deptname`,`id`'); $_uarr= array(); foreach($uarr as $k=>$rs)$_uarr[$rs['id']] = $rs; foreach($rows as $k=>$rs){ if(isset($_uarr[$rs['uid']])){ $rows[$k]['name'] = $_uarr[$rs['uid']]['name']; $rows[$k]['deptname'] = $_uarr[$rs['uid']]['deptname']; } } return $rows; } public function getstatus($ztarr, $rs1, $sp) { $nzt = $rs1['status']; $ztname = ''; if($nzt==5){ $ztname = '<font color=#888888>已删除</font>'; return $ztname; } if(isset($ztarr[$rs1['nstatus']]) && !$this->isempt($rs1['statusman'])){ $ztname = ''.$rs1['statusman'].'<font color="'.$ztarr[$rs1['nstatus']][1].'">'.$ztarr[$rs1['nstatus']][0].'</font>'.$sp.''; } if(!$this->isempt($rs1['nowcheckname'])){ $ztname .= '<font color=blue>待'.$rs1['nowcheckname'].'处理</font>'; } return $ztname; } public function totaldaiban($uid) { $mwhere = m('where'); $arows = m('flow_set')->getall('isflow=1 order by `sort`', "`num`,`name`,`table`,`menunum`"); $total = 0; foreach($arows as $k=>$rs){ $whre = $mwhere->getstring('flowset_'.$rs['num']); $arows[$k]['where'] = $whre; $to = m($rs['table'])->rows("`status`=0 and ifnull(uid, 0)>0 and `isturn`=1 and instr(concat(',', nowcheckid, ','), ',$uid,')>0 $whre"); $total += $to; } return $total; } }